Dataset info
| Number of variables | 75 |
|---|---|
| Number of observations | 877986 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 502.4 MiB |
| Average record size in memory | 600.0 B |
Variables types
| Numeric | 47 |
|---|---|
| Categorical | 13 |
| Boolean | 3 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 12 |
| Unsupported | 0 |
Warnings
acc_now_delinq has 873344 (99.5%) zeros | Zeros |
acc_open_past_24mths has 36913 (4.2%) zeros | Zeros |
annual_inc is highly skewed (γ1 = 481.5767234) | Skewed |
chargeoff_within_12_mths has 870928 (99.2%) zeros | Zeros |
collection_recovery_fee has 833279 (94.9%) zeros | Zeros |
collections_12_mths_ex_med has 860256 (98.0%) zeros | Zeros |
delinq_2yrs has 699379 (79.7%) zeros | Zeros |
delinq_amnt is highly skewed (γ1 = 86.71946315) | Skewed |
delinq_amnt has 873983 (99.5%) zeros | Zeros |
earliest_cr_line has a high cardinality: 709 distinct values | Warning |
fico_range_low is highly correlated with fico_range_high (ρ = 0.9999999033) | Rejected |
funded_amnt_inv is highly correlated with funded_amnt (ρ = 0.9999934741) | Rejected |
installment is highly correlated with funded_amnt_inv (ρ = 0.9482554488) | Rejected |
last_fico_range_low has 11866 (1.4%) zeros | Zeros |
loan_amnt is highly correlated with installment (ρ = 0.9483703021) | Rejected |
mo_sin_rcnt_rev_tl_op has 13591 (1.5%) zeros | Zeros |
mo_sin_rcnt_tl has 14028 (1.6%) zeros | Zeros |
mort_acc has 370578 (42.2%) zeros | Zeros |
num_accts_ever_120_pd has 666796 (75.9%) zeros | Zeros |
num_actv_bc_tl has 20219 (2.3%) zeros | Zeros |
num_bc_sats has 9947 (1.1%) zeros | Zeros |
num_il_tl has 24904 (2.8%) zeros | Zeros |
num_rev_tl_bal_gt_0 is highly correlated with num_actv_rev_tl (ρ = 0.9784947354) | Rejected |
num_tl_30dpd has 874894 (99.6%) zeros | Zeros |
num_tl_90g_dpd_24m has 828135 (94.3%) zeros | Zeros |
num_tl_op_past_12m has 163858 (18.7%) zeros | Zeros |
open_acc is highly correlated with num_sats (ρ = 0.9988132903) | Rejected |
out_prncp has 345363 (39.3%) zeros | Zeros |
out_prncp_inv is highly correlated with out_prncp (ρ = 0.9999980186) | Rejected |
policy_code has constant value "1" | Rejected |
pub_rec has 718878 (81.9%) zeros | Zeros |
pub_rec_bankruptcies has 764266 (87.0%) zeros | Zeros |
recoveries is highly correlated with collection_recovery_fee (ρ = 0.9864791705) | Rejected |
tax_liens is highly skewed (γ1 = 23.34781072) | Skewed |
tax_liens has 843069 (96.0%) zeros | Zeros |
tot_coll_amt is highly skewed (γ1 = 151.083683) | Skewed |
tot_coll_amt has 729825 (83.1%) zeros | Zeros |
tot_hi_cred_lim is highly correlated with tot_cur_bal (ρ = 0.972754613) | Rejected |
total_bc_limit has 10424 (1.2%) zeros | Zeros |
total_il_high_credit_limit has 94263 (10.7%) zeros | Zeros |
total_pymnt_inv is highly correlated with total_pymnt (ρ = 0.9999946425) | Rejected |
total_rec_late_fee is highly skewed (γ1 = 20.29350981) | Skewed |
total_rec_late_fee has 844499 (96.2%) zeros | Zeros |
total_rec_prncp is highly correlated with total_pymnt_inv (ρ = 0.9665829516) | Rejected |
acc_now_delinq
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.005606011941 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros (%) | 99.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.079666892 |
|---|---|
| Coef of variation | 14.21097437 |
| Kurtosis | 396.9390178 |
| Mean | 0.005606011941 |
| MAD | 0.01115274479 |
| Skewness | 16.71443451 |
| Sum | 4922 |
| Variance | 0.00634681368 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 873344 | 99.5% | |
| 1 | 4401 | 0.5% | |
| 2 | 213 | < 0.1% | |
| 3 | 22 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 873344 | 99.5% | |
| 1 | 4401 | 0.5% | |
| 2 | 213 | < 0.1% | |
| 3 | 22 | < 0.1% | |
| 4 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 3 | 22 | < 0.1% | |
| 2 | 213 | < 0.1% |
acc_open_past_24mths
Numeric
| Distinct count | 52 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.659733754 |
|---|---|
| Minimum | 0 |
| Maximum | 61 |
| Zeros (%) | 4.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 4 |
| Q3 | 6 |
| 95-th percentile | 11 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 3.262668052 |
|---|---|
| Coef of variation | 0.7001833633 |
| Kurtosis | 4.763240446 |
| Mean | 4.659733754 |
| MAD | 2.483325368 |
| Skewness | 1.451089178 |
| Sum | 4091181 |
| Variance | 10.64500282 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 3 | 129315 | 14.7% | |
| 4 | 120911 | 13.8% | |
| 2 | 117647 | 13.4% | |
| 5 | 102741 | 11.7% | |
| 1 | 84938 | 9.7% | |
| 6 | 80886 | 9.2% | |
| 7 | 61014 | 6.9% | |
| 8 | 44203 | 5.0% | |
| 0 | 36913 | 4.2% | |
| 9 | 31224 | 3.6% | |
| Other values (42) | 68194 | 7.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 36913 | 4.2% | |
| 1 | 84938 | 9.7% | |
| 2 | 117647 | 13.4% | |
| 3 | 129315 | 14.7% | |
| 4 | 120911 | 13.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 61 | 1 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| 54 | 2 | < 0.1% | |
| 49 | 2 | < 0.1% |
addr_state
Categorical
| Distinct count | 50 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CA | 117739 |
|---|---|
| TX | 74295 |
| NY | 72705 |
| Other values (47) |
| Value | Count | Frequency (%) | |
| CA | 117739 | 13.4% | |
| TX | 74295 | 8.5% | |
| NY | 72705 | 8.3% | |
| FL | 63663 | 7.3% | |
| IL | 36022 | 4.1% | |
| NJ | 32066 | 3.7% | |
| PA | 29547 | 3.4% | |
| OH | 29463 | 3.4% | |
| GA | 28712 | 3.3% | |
| NC | 24375 | 2.8% | |
| Other values (40) | 369399 | 42.1% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
annual_inc
Numeric
| Distinct count | 46617 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 79805.0889 |
|---|---|
| Minimum | 0 |
| Maximum | 110000000 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 28000 |
| Q1 | 47500 |
| Median | 66000 |
| Q3 | 95000 |
| 95-th percentile | 166000 |
| Maximum | 110000000 |
| Range | 110000000 |
| Interquartile range | 47500 |
Descriptive statistics
| Standard deviation | 154922.5767 |
|---|---|
| Coef of variation | 1.941261878 |
| Kurtosis | 316133.8167 |
| Mean | 79805.0889 |
| MAD | 35726.73393 |
| Skewness | 481.5767234 |
| Sum | 7.006775078e+10 |
| Variance | 2.400100478e+10 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 60000 | 33974 | 3.9% | |
| 50000 | 29252 | 3.3% | |
| 65000 | 25228 | 2.9% | |
| 70000 | 24271 | 2.8% | |
| 80000 | 23598 | 2.7% | |
| 75000 | 23037 | 2.6% | |
| 40000 | 22726 | 2.6% | |
| 45000 | 20494 | 2.3% | |
| 55000 | 19739 | 2.2% | |
| 100000 | 18679 | 2.1% | |
| Other values (46607) | 636988 | 72.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 550 | 0.1% | |
| 0.36 | 1 | < 0.1% | |
| 1 | 21 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 110000000 | 1 | < 0.1% | |
| 61000000 | 1 | < 0.1% | |
| 10999200 | 1 | < 0.1% | |
| 9573072 | 1 | < 0.1% | |
| 9550000 | 1 | < 0.1% |
application_type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Individual | |
|---|---|
| Joint App | 51214 |
| Value | Count | Frequency (%) | |
| Individual | 826772 | 94.2% | |
| Joint App | 51214 | 5.8% |
| Max length | 10 |
|---|---|
| Mean length | 9.941668774 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
chargeoff_within_12_mths
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.008942056024 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 99.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1082632187 |
|---|---|
| Coef of variation | 12.1071953 |
| Kurtosis | 617.3394845 |
| Mean | 0.008942056024 |
| MAD | 0.01774034431 |
| Skewness | 18.28569017 |
| Sum | 7851 |
| Variance | 0.01172092452 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 870928 | 99.2% | |
| 1 | 6513 | 0.7% | |
| 2 | 405 | < 0.1% | |
| 3 | 83 | < 0.1% | |
| 4 | 34 | < 0.1% | |
| 5 | 11 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 870928 | 99.2% | |
| 1 | 6513 | 0.7% | |
| 2 | 405 | < 0.1% | |
| 3 | 83 | < 0.1% | |
| 4 | 34 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 5 | 11 | < 0.1% |
collection_recovery_fee
Numeric
| Distinct count | 38735 |
|---|---|
| Unique (%) | 4.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.44041308 |
|---|---|
| Minimum | 0 |
| Maximum | 7174.719 |
| Zeros (%) | 94.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 11.6352 |
| Maximum | 7174.719 |
| Range | 7174.719 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 101.8510925 |
|---|---|
| Coef of variation | 6.195166267 |
| Kurtosis | 315.9564187 |
| Mean | 16.44041308 |
| MAD | 31.22513432 |
| Skewness | 12.73134475 |
| Sum | 14434452.52 |
| Variance | 10373.64505 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 833279 | 94.9% | |
| 9 | 305 | < 0.1% | |
| 18 | 300 | < 0.1% | |
| 27 | 178 | < 0.1% | |
| 36 | 166 | < 0.1% | |
| 4.5 | 159 | < 0.1% | |
| 13.5 | 118 | < 0.1% | |
| 54 | 114 | < 0.1% | |
| 45 | 92 | < 0.1% | |
| 72 | 78 | < 0.1% | |
| Other values (38725) | 43197 | 4.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 833279 | 94.9% | |
| 0.3082 | 1 | < 0.1% | |
| 0.378 | 1 | < 0.1% | |
| 0.809999997 | 1 | < 0.1% | |
| 0.8514 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7174.719 | 1 | < 0.1% | |
| 6687.6228 | 1 | < 0.1% | |
| 6584.1372 | 1 | < 0.1% | |
| 5510.133 | 1 | < 0.1% | |
| 5381.1288 | 1 | < 0.1% |
collections_12_mths_ex_med
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02221561619 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros (%) | 98.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1679709665 |
|---|---|
| Coef of variation | 7.560941142 |
| Kurtosis | 488.6881999 |
| Mean | 0.02221561619 |
| MAD | 0.04353399058 |
| Skewness | 12.92177996 |
| Sum | 19505 |
| Variance | 0.02821424558 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 860256 | 98.0% | |
| 1 | 16410 | 1.9% | |
| 2 | 1086 | 0.1% | |
| 3 | 136 | < 0.1% | |
| 4 | 52 | < 0.1% | |
| 5 | 21 | < 0.1% | |
| 6 | 10 | < 0.1% | |
| 7 | 6 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| Other values (4) | 4 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 860256 | 98.0% | |
| 1 | 16410 | 1.9% | |
| 2 | 1086 | 0.1% | |
| 3 | 136 | < 0.1% | |
| 4 | 52 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 20 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 3 | < 0.1% |
debt_settlement_flag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 10450 |
| Value | Count | Frequency (%) | |
| N | 867536 | 98.8% | |
| Y | 10450 | 1.2% |
delinq_2yrs
Numeric
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3430248318 |
|---|---|
| Minimum | 0 |
| Maximum | 42 |
| Zeros (%) | 79.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 42 |
| Range | 42 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.9318478553 |
|---|---|
| Coef of variation | 2.716560927 |
| Kurtosis | 61.73846831 |
| Mean | 0.3430248318 |
| MAD | 0.5464879027 |
| Skewness | 5.672934529 |
| Sum | 301171 |
| Variance | 0.8683404254 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 699379 | 79.7% | |
| 1 | 117081 | 13.3% | |
| 2 | 34949 | 4.0% | |
| 3 | 13136 | 1.5% | |
| 4 | 5875 | 0.7% | |
| 5 | 2981 | 0.3% | |
| 6 | 1728 | 0.2% | |
| 7 | 1005 | 0.1% | |
| 8 | 593 | 0.1% | |
| 9 | 399 | < 0.1% | |
| Other values (22) | 860 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 699379 | 79.7% | |
| 1 | 117081 | 13.3% | |
| 2 | 34949 | 4.0% | |
| 3 | 13136 | 1.5% | |
| 4 | 5875 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 32 | 1 | < 0.1% | |
| 30 | 1 | < 0.1% | |
| 29 | 1 | < 0.1% |
delinq_amnt
Numeric
| Distinct count | 1817 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19.69888244 |
|---|---|
| Minimum | 0 |
| Maximum | 249925 |
| Zeros (%) | 99.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 249925 |
| Range | 249925 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 942.7004631 |
|---|---|
| Coef of variation | 47.85553017 |
| Kurtosis | 11740.37531 |
| Mean | 19.69888244 |
| MAD | 39.2215967 |
| Skewness | 86.71946315 |
| Sum | 17295343 |
| Variance | 888684.1631 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 873983 | 99.5% | |
| 25 | 88 | < 0.1% | |
| 65000 | 75 | < 0.1% | |
| 57 | 37 | < 0.1% | |
| 30 | 36 | < 0.1% | |
| 54 | 34 | < 0.1% | |
| 53 | 34 | < 0.1% | |
| 50 | 33 | < 0.1% | |
| 56 | 31 | < 0.1% | |
| 35 | 28 | < 0.1% | |
| Other values (1807) | 3607 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 873983 | 99.5% | |
| 1 | 7 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 3 | 8 | < 0.1% | |
| 4 | 11 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 249925 | 1 | < 0.1% | |
| 185408 | 1 | < 0.1% | |
| 138474 | 1 | < 0.1% | |
| 130778 | 1 | < 0.1% | |
| 112524 | 1 | < 0.1% |
df_index
Numeric
| Distinct count | 133887 |
|---|---|
| Unique (%) | 15.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 55619.21042 |
|---|---|
| Minimum | 0 |
| Maximum | 133886 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5487 |
| Q1 | 27437 |
| Median | 54874 |
| Q3 | 82311 |
| 95-th percentile | 110445 |
| Maximum | 133886 |
| Range | 133886 |
| Interquartile range | 54874 |
Descriptive statistics
| Standard deviation | 33005.8217 |
|---|---|
| Coef of variation | 0.5934248518 |
| Kurtosis | -0.9813619468 |
| Mean | 55619.21042 |
| MAD | 28187.71313 |
| Skewness | 0.1430938585 |
| Sum | 4.883288808e+10 |
| Variance | 1089384266 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 2047 | 8 | < 0.1% | |
| 67301 | 8 | < 0.1% | |
| 65242 | 8 | < 0.1% | |
| 63195 | 8 | < 0.1% | |
| 52956 | 8 | < 0.1% | |
| 50909 | 8 | < 0.1% | |
| 57054 | 8 | < 0.1% | |
| 55007 | 8 | < 0.1% | |
| 77536 | 8 | < 0.1% | |
| 75489 | 8 | < 0.1% | |
| Other values (133877) | 877906 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 8 | < 0.1% | |
| 1 | 8 | < 0.1% | |
| 2 | 8 | < 0.1% | |
| 3 | 8 | < 0.1% | |
| 4 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 133886 | 1 | < 0.1% | |
| 133885 | 1 | < 0.1% | |
| 133884 | 1 | < 0.1% | |
| 133883 | 1 | < 0.1% | |
| 133882 | 1 | < 0.1% |
disbursement_method
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Cash | |
|---|---|
| DirectPay | 6764 |
| Value | Count | Frequency (%) | |
| Cash | 871222 | 99.2% | |
| DirectPay | 6764 | 0.8% |
| Max length | 9 |
|---|---|
| Mean length | 4.038519976 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
earliest_cr_line
Categorical
| Distinct count | 709 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Sep-05 | 6687 |
|---|---|
| Sep-04 | 6650 |
| Aug-04 | 6412 |
| Other values (706) |
| Value | Count | Frequency (%) | |
| Sep-05 | 6687 | 0.8% | |
| Sep-04 | 6650 | 0.8% | |
| Aug-04 | 6412 | 0.7% | |
| Sep-03 | 6372 | 0.7% | |
| Aug-05 | 6356 | 0.7% | |
| Aug-03 | 6303 | 0.7% | |
| Aug-06 | 6091 | 0.7% | |
| Oct-03 | 5965 | 0.7% | |
| Oct-04 | 5911 | 0.7% | |
| Aug-02 | 5717 | 0.7% | |
| Other values (699) | 815522 | 92.9% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
fico_range_high
Numeric
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 701.8635081 |
|---|---|
| Minimum | 664 |
| Maximum | 850 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 664 |
|---|---|
| 5-th percentile | 664 |
| Q1 | 674 |
| Median | 694 |
| Q3 | 719 |
| 95-th percentile | 769 |
| Maximum | 850 |
| Range | 186 |
| Interquartile range | 45 |
Descriptive statistics
| Standard deviation | 32.93544331 |
|---|---|
| Coef of variation | 0.04692570982 |
| Kurtosis | 1.438569926 |
| Mean | 701.8635081 |
| MAD | 25.74123018 |
| Skewness | 1.226548943 |
| Sum | 616226334 |
| Variance | 1084.743426 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 664 | 77523 | 8.8% | |
| 669 | 73290 | 8.3% | |
| 674 | 72175 | 8.2% | |
| 684 | 65119 | 7.4% | |
| 679 | 64462 | 7.3% | |
| 689 | 56694 | 6.5% | |
| 694 | 55524 | 6.3% | |
| 699 | 49706 | 5.7% | |
| 704 | 47826 | 5.4% | |
| 709 | 43060 | 4.9% | |
| Other values (28) | 272607 | 31.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 664 | 77523 | 8.8% | |
| 669 | 73290 | 8.3% | |
| 674 | 72175 | 8.2% | |
| 679 | 64462 | 7.3% | |
| 684 | 65119 | 7.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 850 | 185 | < 0.1% | |
| 844 | 256 | < 0.1% | |
| 839 | 347 | < 0.1% | |
| 834 | 587 | 0.1% | |
| 829 | 862 | 0.1% |
fico_range_low
Highly correlated
This variable is highly correlated with fico_range_high and should be ignored for analysis
| Correlation | 0.9999999033 |
|---|
funded_amnt
Numeric
| Distinct count | 1560 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14790.09776 |
|---|---|
| Minimum | 1000 |
| Maximum | 40000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 3000 |
| Q1 | 7500 |
| Median | 12000 |
| Q3 | 20000 |
| 95-th percentile | 35000 |
| Maximum | 40000 |
| Range | 39000 |
| Interquartile range | 12500 |
Descriptive statistics
| Standard deviation | 9321.148083 |
|---|---|
| Coef of variation | 0.6302289702 |
| Kurtosis | -0.1175966129 |
| Mean | 14790.09776 |
| MAD | 7563.617806 |
| Skewness | 0.8038443875 |
| Sum | 1.298549878e+10 |
| Variance | 86883801.58 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 10000 | 69756 | 7.9% | |
| 20000 | 48229 | 5.5% | |
| 12000 | 47703 | 5.4% | |
| 15000 | 45620 | 5.2% | |
| 5000 | 36217 | 4.1% | |
| 35000 | 32655 | 3.7% | |
| 8000 | 31928 | 3.6% | |
| 6000 | 30539 | 3.5% | |
| 16000 | 27569 | 3.1% | |
| 30000 | 24035 | 2.7% | |
| Other values (1550) | 483735 | 55.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1000 | 4495 | 0.5% | |
| 1025 | 16 | < 0.1% | |
| 1050 | 24 | < 0.1% | |
| 1075 | 9 | < 0.1% | |
| 1100 | 108 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40000 | 13052 | 1.5% | |
| 39975 | 7 | < 0.1% | |
| 39950 | 3 | < 0.1% | |
| 39925 | 5 | < 0.1% | |
| 39900 | 8 | < 0.1% |
funded_amnt_inv
Highly correlated
This variable is highly correlated with funded_amnt and should be ignored for analysis
| Correlation | 0.9999934741 |
|---|
grade
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| C | |
|---|---|
| B | |
| A | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| C | 277322 | 31.6% | |
| B | 267639 | 30.5% | |
| A | 149643 | 17.0% | |
| D | 115824 | 13.2% | |
| E | 45974 | 5.2% | |
| F | 15576 | 1.8% | |
| G | 6008 | 0.7% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
hardship_flag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 948 |
| Value | Count | Frequency (%) | |
| N | 877038 | 99.9% | |
| Y | 948 | 0.1% |
home_ownership
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MORTGAGE | |
|---|---|
| RENT | |
| OWN | |
| Other values (2) | 509 |
| Value | Count | Frequency (%) | |
| MORTGAGE | 428639 | 48.8% | |
| RENT | 343387 | 39.1% | |
| OWN | 105451 | 12.0% | |
| ANY | 505 | 0.1% | |
| NONE | 4 | < 0.1% |
| Max length | 8 |
|---|---|
| Mean length | 5.832147665 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
initial_list_status
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| w | |
|---|---|
| f |
| Value | Count | Frequency (%) | |
| w | 677742 | 77.2% | |
| f | 200244 | 22.8% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
installment
Highly correlated
This variable is highly correlated with funded_amnt_inv and should be ignored for analysis
| Correlation | 0.9482554488 |
|---|
int_rate
Numeric
| Distinct count | 170 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.14438129 |
|---|---|
| Minimum | 5.32 |
| Maximum | 30.99 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 5.32 |
|---|---|
| 5-th percentile | 6.49 |
| Q1 | 9.49 |
| Median | 12.62 |
| Q3 | 15.59 |
| 95-th percentile | 23.88 |
| Maximum | 30.99 |
| Range | 25.67 |
| Interquartile range | 6.1 |
Descriptive statistics
| Standard deviation | 5.06407089 |
|---|---|
| Coef of variation | 0.3852650634 |
| Kurtosis | 1.059300223 |
| Mean | 13.14438129 |
| MAD | 3.886553356 |
| Skewness | 0.973944813 |
| Sum | 11540582.75 |
| Variance | 25.64481398 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 5.32 | 34988 | 4.0% | |
| 11.99 | 34292 | 3.9% | |
| 11.49 | 28896 | 3.3% | |
| 13.99 | 23957 | 2.7% | |
| 13.49 | 23235 | 2.6% | |
| 16.02 | 20509 | 2.3% | |
| 12.74 | 19990 | 2.3% | |
| 12.62 | 19663 | 2.2% | |
| 10.42 | 19235 | 2.2% | |
| 9.44 | 18919 | 2.2% | |
| Other values (160) | 634302 | 72.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 5.32 | 34988 | 4.0% | |
| 6 | 274 | < 0.1% | |
| 6.08 | 2670 | 0.3% | |
| 6.24 | 9 | < 0.1% | |
| 6.49 | 6416 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30.99 | 792 | 0.1% | |
| 30.94 | 708 | 0.1% | |
| 30.89 | 655 | 0.1% | |
| 30.84 | 667 | 0.1% | |
| 30.79 | 1085 | 0.1% |
issue_d
Categorical
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mar-16 | 61992 |
|---|---|
| Aug-17 | 43573 |
| Nov-17 | 42343 |
| Other values (21) |
| Value | Count | Frequency (%) | |
| Mar-16 | 61992 | 7.1% | |
| Aug-17 | 43573 | 5.0% | |
| Nov-17 | 42343 | 4.8% | |
| Sep-17 | 39713 | 4.5% | |
| Feb-16 | 39529 | 4.5% | |
| Jul-17 | 39415 | 4.5% | |
| Dec-17 | 38154 | 4.3% | |
| Oct-17 | 38151 | 4.3% | |
| Jun-17 | 38087 | 4.3% | |
| May-17 | 37681 | 4.3% | |
| Other values (14) | 459348 | 52.3% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
last_fico_range_high
Numeric
| Distinct count | 72 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 688.4523364 |
|---|---|
| Minimum | 0 |
| Maximum | 850 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 544 |
| Q1 | 659 |
| Median | 699 |
| Q3 | 729 |
| 95-th percentile | 789 |
| Maximum | 850 |
| Range | 850 |
| Interquartile range | 70 |
Descriptive statistics
| Standard deviation | 68.32214293 |
|---|---|
| Coef of variation | 0.09924019329 |
| Kurtosis | 0.7346573402 |
| Mean | 688.4523364 |
| MAD | 51.36481061 |
| Skewness | -0.7675556368 |
| Sum | 604451513 |
| Variance | 4667.915215 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 694 | 35363 | 4.0% | |
| 699 | 34749 | 4.0% | |
| 704 | 34453 | 3.9% | |
| 709 | 34035 | 3.9% | |
| 684 | 33883 | 3.9% | |
| 714 | 33108 | 3.8% | |
| 689 | 33065 | 3.8% | |
| 719 | 31941 | 3.6% | |
| 724 | 30783 | 3.5% | |
| 679 | 29984 | 3.4% | |
| Other values (62) | 546622 | 62.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 22 | < 0.1% | |
| 499 | 11844 | 1.3% | |
| 504 | 2518 | 0.3% | |
| 509 | 2859 | 0.3% | |
| 514 | 3276 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 850 | 102 | < 0.1% | |
| 844 | 275 | < 0.1% | |
| 839 | 461 | 0.1% | |
| 834 | 1014 | 0.1% | |
| 829 | 1738 | 0.2% |
last_fico_range_low
Numeric
| Distinct count | 71 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 677.774788 |
|---|---|
| Minimum | 0 |
| Maximum | 845 |
| Zeros (%) | 1.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 540 |
| Q1 | 655 |
| Median | 695 |
| Q3 | 725 |
| 95-th percentile | 785 |
| Maximum | 845 |
| Range | 845 |
| Interquartile range | 70 |
Descriptive statistics
| Standard deviation | 102.2677072 |
|---|---|
| Coef of variation | 0.1508874467 |
| Kurtosis | 23.58245973 |
| Mean | 677.774788 |
| MAD | 59.34179145 |
| Skewness | -3.990956813 |
| Sum | 595076775 |
| Variance | 10458.68394 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 690 | 35363 | 4.0% | |
| 695 | 34749 | 4.0% | |
| 700 | 34453 | 3.9% | |
| 705 | 34035 | 3.9% | |
| 680 | 33883 | 3.9% | |
| 710 | 33108 | 3.8% | |
| 685 | 33065 | 3.8% | |
| 715 | 31941 | 3.6% | |
| 720 | 30783 | 3.5% | |
| 675 | 29984 | 3.4% | |
| Other values (61) | 546622 | 62.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 11866 | 1.4% | |
| 500 | 2518 | 0.3% | |
| 505 | 2859 | 0.3% | |
| 510 | 3276 | 0.4% | |
| 515 | 3536 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 845 | 102 | < 0.1% | |
| 840 | 275 | < 0.1% | |
| 835 | 461 | 0.1% | |
| 830 | 1014 | 0.1% | |
| 825 | 1738 | 0.2% |
last_pymnt_amnt
Numeric
| Distinct count | 291190 |
|---|---|
| Unique (%) | 33.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3223.427883 |
|---|---|
| Minimum | 0 |
| Maximum | 42192.05 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 106.95 |
| Q1 | 288.5 |
| Median | 526.63 |
| Q3 | 2412.48 |
| 95-th percentile | 17267.5325 |
| Maximum | 42192.05 |
| Range | 42192.05 |
| Interquartile range | 2123.98 |
Descriptive statistics
| Standard deviation | 6144.658282 |
|---|---|
| Coef of variation | 1.906249652 |
| Kurtosis | 7.925814539 |
| Mean | 3223.427883 |
| MAD | 4121.576768 |
| Skewness | 2.7438481 |
| Sum | 2830124554 |
| Variance | 37756825.4 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 301.15 | 2046 | 0.2% | |
| 332.1 | 1791 | 0.2% | |
| 329.72 | 1518 | 0.2% | |
| 361.38 | 1419 | 0.2% | |
| 602.3 | 1394 | 0.2% | |
| 451.73 | 1377 | 0.2% | |
| 324.65 | 1322 | 0.2% | |
| 320.05 | 1265 | 0.1% | |
| 326.97 | 1259 | 0.1% | |
| 335.12 | 1200 | 0.1% | |
| Other values (291180) | 863395 | 98.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1182 | 0.1% | |
| 0.01 | 68 | < 0.1% | |
| 0.02 | 12 | < 0.1% | |
| 0.03 | 6 | < 0.1% | |
| 0.04 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42192.05 | 1 | < 0.1% | |
| 42148.53 | 1 | < 0.1% | |
| 42005.2 | 1 | < 0.1% | |
| 41453.07 | 1 | < 0.1% | |
| 41434 | 1 | < 0.1% |
loan_amnt
Highly correlated
This variable is highly correlated with installment and should be ignored for analysis
| Correlation | 0.9483703021 |
|---|
loan_status
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Current | |
|---|---|
| Fully Paid | |
| Charged Off | 80804 |
| Other values (4) | 29582 |
| Value | Count | Frequency (%) | |
| Current | 503359 | 57.3% | |
| Fully Paid | 264241 | 30.1% | |
| Charged Off | 80804 | 9.2% | |
| Late (31-120 days) | 16259 | 1.9% | |
| In Grace Period | 8052 | 0.9% | |
| Late (16-30 days) | 4505 | 0.5% | |
| Default | 766 | 0.1% |
| Max length | 18 |
|---|---|
| Mean length | 8.599403635 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
mo_sin_old_rev_tl_op
Numeric
| Distinct count | 744 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 182.3199618 |
|---|---|
| Minimum | 1 |
| Maximum | 999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 47 |
| Q1 | 117 |
| Median | 164 |
| Q3 | 234 |
| 95-th percentile | 372 |
| Maximum | 999 |
| Range | 998 |
| Interquartile range | 117 |
Descriptive statistics
| Standard deviation | 98.46138068 |
|---|---|
| Coef of variation | 0.5400471769 |
| Kurtosis | 1.282080379 |
| Mean | 182.3199618 |
| MAD | 76.15936788 |
| Skewness | 0.9804793666 |
| Sum | 160074374 |
| Variance | 9694.643484 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 132 | 5265 | 0.6% | |
| 125 | 5226 | 0.6% | |
| 130 | 5211 | 0.6% | |
| 129 | 5179 | 0.6% | |
| 136 | 5171 | 0.6% | |
| 133 | 5128 | 0.6% | |
| 126 | 5120 | 0.6% | |
| 135 | 5109 | 0.6% | |
| 127 | 5101 | 0.6% | |
| 124 | 5096 | 0.6% | |
| Other values (734) | 826380 | 94.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 5 | 14 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999 | 1 | < 0.1% | |
| 901 | 1 | < 0.1% | |
| 852 | 1 | < 0.1% | |
| 836 | 1 | < 0.1% | |
| 821 | 1 | < 0.1% |
mo_sin_rcnt_rev_tl_op
Numeric
| Distinct count | 292 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.91459773 |
|---|---|
| Minimum | 0 |
| Maximum | 547 |
| Zeros (%) | 1.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| Median | 8 |
| Q3 | 17 |
| 95-th percentile | 45 |
| Maximum | 547 |
| Range | 547 |
| Interquartile range | 13 |
Descriptive statistics
| Standard deviation | 17.57807197 |
|---|---|
| Coef of variation | 1.263282799 |
| Kurtosis | 23.2576125 |
| Mean | 13.91459773 |
| MAD | 11.05273815 |
| Skewness | 3.709751662 |
| Sum | 12216822 |
| Variance | 308.9886141 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 2 | 67436 | 7.7% | |
| 3 | 65754 | 7.5% | |
| 4 | 60102 | 6.8% | |
| 1 | 54709 | 6.2% | |
| 5 | 53896 | 6.1% | |
| 6 | 47462 | 5.4% | |
| 7 | 43812 | 5.0% | |
| 8 | 39313 | 4.5% | |
| 9 | 34521 | 3.9% | |
| 10 | 31111 | 3.5% | |
| Other values (282) | 379870 | 43.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 13591 | 1.5% | |
| 1 | 54709 | 6.2% | |
| 2 | 67436 | 7.7% | |
| 3 | 65754 | 7.5% | |
| 4 | 60102 | 6.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 547 | 1 | < 0.1% | |
| 438 | 1 | < 0.1% | |
| 396 | 1 | < 0.1% | |
| 393 | 1 | < 0.1% | |
| 373 | 1 | < 0.1% |
mo_sin_rcnt_tl
Numeric
| Distinct count | 202 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.159731476 |
|---|---|
| Minimum | 0 |
| Maximum | 314 |
| Zeros (%) | 1.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 6 |
| Q3 | 10 |
| 95-th percentile | 23 |
| Maximum | 314 |
| Range | 314 |
| Interquartile range | 7 |
Descriptive statistics
| Standard deviation | 8.993482465 |
|---|---|
| Coef of variation | 1.102178729 |
| Kurtosis | 48.98798084 |
| Mean | 8.159731476 |
| MAD | 5.623877314 |
| Skewness | 4.76692686 |
| Sum | 7164130 |
| Variance | 80.88272686 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 2 | 95240 | 10.8% | |
| 3 | 93410 | 10.6% | |
| 4 | 83093 | 9.5% | |
| 5 | 71489 | 8.1% | |
| 1 | 71478 | 8.1% | |
| 6 | 61160 | 7.0% | |
| 7 | 54360 | 6.2% | |
| 8 | 45881 | 5.2% | |
| 9 | 37987 | 4.3% | |
| 10 | 32700 | 3.7% | |
| Other values (192) | 231188 | 26.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 14028 | 1.6% | |
| 1 | 71478 | 8.1% | |
| 2 | 95240 | 10.8% | |
| 3 | 93410 | 10.6% | |
| 4 | 83093 | 9.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 314 | 1 | < 0.1% | |
| 289 | 1 | < 0.1% | |
| 283 | 1 | < 0.1% | |
| 272 | 1 | < 0.1% | |
| 268 | 1 | < 0.1% |
mort_acc
Numeric
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.484670598 |
|---|---|
| Minimum | 0 |
| Maximum | 94 |
| Zeros (%) | 42.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 94 |
| Range | 94 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.808425371 |
|---|---|
| Coef of variation | 1.218065053 |
| Kurtosis | 14.8338169 |
| Mean | 1.484670598 |
| MAD | 1.433236482 |
| Skewness | 1.842605622 |
| Sum | 1303520 |
| Variance | 3.270402321 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 370578 | 42.2% | |
| 1 | 162986 | 18.6% | |
| 2 | 133820 | 15.2% | |
| 3 | 92167 | 10.5% | |
| 4 | 56990 | 6.5% | |
| 5 | 31032 | 3.5% | |
| 6 | 15803 | 1.8% | |
| 7 | 7411 | 0.8% | |
| 8 | 3544 | 0.4% | |
| 9 | 1700 | 0.2% | |
| Other values (29) | 1955 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 370578 | 42.2% | |
| 1 | 162986 | 18.6% | |
| 2 | 133820 | 15.2% | |
| 3 | 92167 | 10.5% | |
| 4 | 56990 | 6.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 94 | 1 | < 0.1% | |
| 61 | 1 | < 0.1% | |
| 51 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% |
num_accts_ever_120_pd
Numeric
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5359128733 |
|---|---|
| Minimum | 0 |
| Maximum | 51 |
| Zeros (%) | 75.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 51 |
| Range | 51 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.428509243 |
|---|---|
| Coef of variation | 2.665562471 |
| Kurtosis | 53.77908784 |
| Mean | 0.5359128733 |
| MAD | 0.8140097001 |
| Skewness | 5.512583888 |
| Sum | 470524 |
| Variance | 2.040638657 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 666796 | 75.9% | |
| 1 | 112092 | 12.8% | |
| 2 | 44275 | 5.0% | |
| 3 | 20746 | 2.4% | |
| 4 | 12252 | 1.4% | |
| 5 | 7182 | 0.8% | |
| 6 | 4835 | 0.6% | |
| 7 | 3067 | 0.3% | |
| 8 | 2043 | 0.2% | |
| 9 | 1318 | 0.2% | |
| Other values (32) | 3380 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 666796 | 75.9% | |
| 1 | 112092 | 12.8% | |
| 2 | 44275 | 5.0% | |
| 3 | 20746 | 2.4% | |
| 4 | 12252 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 38 | 1 | < 0.1% |
num_actv_bc_tl
Numeric
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.662168873 |
|---|---|
| Minimum | 0 |
| Maximum | 47 |
| Zeros (%) | 2.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 47 |
| Range | 47 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 2.361752043 |
|---|---|
| Coef of variation | 0.64490528 |
| Kurtosis | 5.052618239 |
| Mean | 3.662168873 |
| MAD | 1.777100994 |
| Skewness | 1.548370467 |
| Sum | 3215333 |
| Variance | 5.57787271 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 3 | 182286 | 20.8% | |
| 2 | 180084 | 20.5% | |
| 4 | 140458 | 16.0% | |
| 1 | 107452 | 12.2% | |
| 5 | 94053 | 10.7% | |
| 6 | 59411 | 6.8% | |
| 7 | 36316 | 4.1% | |
| 8 | 22131 | 2.5% | |
| 0 | 20219 | 2.3% | |
| 9 | 13564 | 1.5% | |
| Other values (29) | 22012 | 2.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20219 | 2.3% | |
| 1 | 107452 | 12.2% | |
| 2 | 180084 | 20.5% | |
| 3 | 182286 | 20.8% | |
| 4 | 140458 | 16.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 47 | 1 | < 0.1% | |
| 46 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 36 | 2 | < 0.1% | |
| 35 | 1 | < 0.1% |
num_actv_rev_tl
Numeric
| Distinct count | 55 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.614002957 |
|---|---|
| Minimum | 0 |
| Maximum | 63 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| Median | 5 |
| Q3 | 7 |
| 95-th percentile | 12 |
| Maximum | 63 |
| Range | 63 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 3.455828121 |
|---|---|
| Coef of variation | 0.6155729071 |
| Kurtosis | 5.583865027 |
| Mean | 5.614002957 |
| MAD | 2.577306607 |
| Skewness | 1.661646067 |
| Sum | 4929016 |
| Variance | 11.942748 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 4 | 133167 | 15.2% | |
| 3 | 125512 | 14.3% | |
| 5 | 119633 | 13.6% | |
| 6 | 97309 | 11.1% | |
| 2 | 89816 | 10.2% | |
| 7 | 74645 | 8.5% | |
| 8 | 55078 | 6.3% | |
| 9 | 40200 | 4.6% | |
| 1 | 35761 | 4.1% | |
| 10 | 28687 | 3.3% | |
| Other values (45) | 78178 | 8.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4515 | 0.5% | |
| 1 | 35761 | 4.1% | |
| 2 | 89816 | 10.2% | |
| 3 | 125512 | 14.3% | |
| 4 | 133167 | 15.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 63 | 1 | < 0.1% | |
| 60 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% | |
| 57 | 2 | < 0.1% | |
| 52 | 1 | < 0.1% |
num_bc_sats
Numeric
| Distinct count | 53 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.779800589 |
|---|---|
| Minimum | 0 |
| Maximum | 71 |
| Zeros (%) | 1.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 4 |
| Q3 | 6 |
| 95-th percentile | 11 |
| Maximum | 71 |
| Range | 71 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 3.131138976 |
|---|---|
| Coef of variation | 0.6550773233 |
| Kurtosis | 7.152841703 |
| Mean | 4.779800589 |
| MAD | 2.302844194 |
| Skewness | 1.825918374 |
| Sum | 4196598 |
| Variance | 9.804031285 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 3 | 151517 | 17.3% | |
| 4 | 140413 | 16.0% | |
| 2 | 124712 | 14.2% | |
| 5 | 112536 | 12.8% | |
| 6 | 83385 | 9.5% | |
| 1 | 62847 | 7.2% | |
| 7 | 58886 | 6.7% | |
| 8 | 40786 | 4.6% | |
| 9 | 27942 | 3.2% | |
| 10 | 19214 | 2.2% | |
| Other values (43) | 55748 | 6.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 9947 | 1.1% | |
| 1 | 62847 | 7.2% | |
| 2 | 124712 | 14.2% | |
| 3 | 151517 | 17.3% | |
| 4 | 140413 | 16.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 71 | 1 | < 0.1% | |
| 61 | 1 | < 0.1% | |
| 54 | 2 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 49 | 2 | < 0.1% |
num_bc_tl
Numeric
| Distinct count | 70 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.431093434 |
|---|---|
| Minimum | 0 |
| Maximum | 79 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| Median | 6 |
| Q3 | 10 |
| 95-th percentile | 16 |
| Maximum | 79 |
| Range | 79 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 4.595423158 |
|---|---|
| Coef of variation | 0.618404707 |
| Kurtosis | 4.458419851 |
| Mean | 7.431093434 |
| MAD | 3.481089097 |
| Skewness | 1.501674051 |
| Sum | 6524396 |
| Variance | 21.117914 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 5 | 96280 | 11.0% | |
| 4 | 94939 | 10.8% | |
| 6 | 90906 | 10.4% | |
| 7 | 81645 | 9.3% | |
| 3 | 79440 | 9.0% | |
| 8 | 70915 | 8.1% | |
| 9 | 58673 | 6.7% | |
| 2 | 53503 | 6.1% | |
| 10 | 48059 | 5.5% | |
| 11 | 38819 | 4.4% | |
| Other values (60) | 164807 | 18.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2667 | 0.3% | |
| 1 | 21873 | 2.5% | |
| 2 | 53503 | 6.1% | |
| 3 | 79440 | 9.0% | |
| 4 | 94939 | 10.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 79 | 1 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 76 | 1 | < 0.1% | |
| 70 | 1 | < 0.1% | |
| 68 | 2 | < 0.1% |
num_il_tl
Numeric
| Distinct count | 112 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.520999196 |
|---|---|
| Minimum | 0 |
| Maximum | 159 |
| Zeros (%) | 2.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 7 |
| Q3 | 11 |
| 95-th percentile | 23 |
| Maximum | 159 |
| Range | 159 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 7.446642019 |
|---|---|
| Coef of variation | 0.8739165265 |
| Kurtosis | 8.241121241 |
| Mean | 8.520999196 |
| MAD | 5.367975128 |
| Skewness | 2.14446278 |
| Sum | 7481318 |
| Variance | 55.45247736 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 4 | 76373 | 8.7% | |
| 3 | 75974 | 8.7% | |
| 5 | 72546 | 8.3% | |
| 2 | 68555 | 7.8% | |
| 6 | 66923 | 7.6% | |
| 7 | 59971 | 6.8% | |
| 8 | 52213 | 5.9% | |
| 1 | 51848 | 5.9% | |
| 9 | 44726 | 5.1% | |
| 10 | 38797 | 4.4% | |
| Other values (102) | 270060 | 30.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 24904 | 2.8% | |
| 1 | 51848 | 5.9% | |
| 2 | 68555 | 7.8% | |
| 3 | 75974 | 8.7% | |
| 4 | 76373 | 8.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 159 | 1 | < 0.1% | |
| 140 | 1 | < 0.1% | |
| 138 | 1 | < 0.1% | |
| 128 | 1 | < 0.1% | |
| 127 | 1 | < 0.1% |
num_op_rev_tl
Numeric
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.224300843 |
|---|---|
| Minimum | 0 |
| Maximum | 91 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| Median | 7 |
| Q3 | 10 |
| 95-th percentile | 17 |
| Maximum | 91 |
| Range | 91 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 4.770680929 |
|---|---|
| Coef of variation | 0.5800713058 |
| Kurtosis | 5.063712718 |
| Mean | 8.224300843 |
| MAD | 3.582973114 |
| Skewness | 1.575254967 |
| Sum | 7220821 |
| Variance | 22.75939653 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 6 | 94499 | 10.8% | |
| 5 | 92995 | 10.6% | |
| 7 | 87414 | 10.0% | |
| 4 | 82774 | 9.4% | |
| 8 | 77700 | 8.8% | |
| 9 | 66481 | 7.6% | |
| 3 | 61479 | 7.0% | |
| 10 | 55117 | 6.3% | |
| 11 | 45020 | 5.1% | |
| 12 | 36390 | 4.1% | |
| Other values (65) | 178117 | 20.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 468 | 0.1% | |
| 1 | 7786 | 0.9% | |
| 2 | 33332 | 3.8% | |
| 3 | 61479 | 7.0% | |
| 4 | 82774 | 9.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 91 | 2 | < 0.1% | |
| 86 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 76 | 1 | < 0.1% |
num_rev_accts
Numeric
| Distinct count | 104 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.67560417 |
|---|---|
| Minimum | 2 |
| Maximum | 143 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 8 |
| Median | 12 |
| Q3 | 18 |
| 95-th percentile | 29 |
| Maximum | 143 |
| Range | 141 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 7.997535897 |
|---|---|
| Coef of variation | 0.5848031136 |
| Kurtosis | 3.863724513 |
| Mean | 13.67560417 |
| MAD | 6.089612815 |
| Skewness | 1.435779548 |
| Sum | 12006989 |
| Variance | 63.96058042 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 9 | 54275 | 6.2% | |
| 10 | 54031 | 6.2% | |
| 8 | 53939 | 6.1% | |
| 11 | 52226 | 5.9% | |
| 7 | 51351 | 5.8% | |
| 12 | 49175 | 5.6% | |
| 6 | 46661 | 5.3% | |
| 13 | 45882 | 5.2% | |
| 14 | 42423 | 4.8% | |
| 5 | 39796 | 4.5% | |
| Other values (94) | 388227 | 44.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 9580 | 1.1% | |
| 3 | 19643 | 2.2% | |
| 4 | 30376 | 3.5% | |
| 5 | 39796 | 4.5% | |
| 6 | 46661 | 5.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 143 | 1 | < 0.1% | |
| 128 | 1 | < 0.1% | |
| 127 | 1 | < 0.1% | |
| 113 | 1 | < 0.1% | |
| 112 | 1 | < 0.1% |
num_rev_tl_bal_gt_0
Highly correlated
This variable is highly correlated with num_actv_rev_tl and should be ignored for analysis
| Correlation | 0.9784947354 |
|---|
num_sats
Numeric
| Distinct count | 82 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11.698092 |
|---|---|
| Minimum | 0 |
| Maximum | 97 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| Median | 11 |
| Q3 | 15 |
| 95-th percentile | 23 |
| Maximum | 97 |
| Range | 97 |
| Interquartile range | 7 |
Descriptive statistics
| Standard deviation | 5.755076867 |
|---|---|
| Coef of variation | 0.4919671403 |
| Kurtosis | 3.525718532 |
| Mean | 11.698092 |
| MAD | 4.378381923 |
| Skewness | 1.341133268 |
| Sum | 10270761 |
| Variance | 33.12090975 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 9 | 74825 | 8.5% | |
| 8 | 72680 | 8.3% | |
| 10 | 72582 | 8.3% | |
| 11 | 67335 | 7.7% | |
| 7 | 67182 | 7.7% | |
| 12 | 60314 | 6.9% | |
| 6 | 56758 | 6.5% | |
| 13 | 52569 | 6.0% | |
| 14 | 45423 | 5.2% | |
| 5 | 42501 | 4.8% | |
| Other values (72) | 265817 | 30.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 13 | < 0.1% | |
| 1 | 572 | 0.1% | |
| 2 | 3803 | 0.4% | |
| 3 | 12742 | 1.5% | |
| 4 | 26430 | 3.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 97 | 1 | < 0.1% | |
| 93 | 1 | < 0.1% | |
| 91 | 1 | < 0.1% | |
| 87 | 1 | < 0.1% | |
| 85 | 1 | < 0.1% |
num_tl_30dpd
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.003687985913 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 99.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.06353409977 |
|---|---|
| Coef of variation | 17.22731628 |
| Kurtosis | 411.4624593 |
| Mean | 0.003687985913 |
| MAD | 0.007349995894 |
| Skewness | 18.81592358 |
| Sum | 3238 |
| Variance | 0.004036581834 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 874894 | 99.6% | |
| 1 | 2958 | 0.3% | |
| 2 | 123 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 874894 | 99.6% | |
| 1 | 2958 | 0.3% | |
| 2 | 123 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 2 | 123 | < 0.1% | |
| 1 | 2958 | 0.3% | |
| 0 | 874894 | 99.6% |
num_tl_90g_dpd_24m
Numeric
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.09083971726 |
|---|---|
| Minimum | 0 |
| Maximum | 42 |
| Zeros (%) | 94.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 42 |
| Range | 42 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.5358187209 |
|---|---|
| Coef of variation | 5.89850714 |
| Kurtosis | 359.2630852 |
| Mean | 0.09083971726 |
| MAD | 0.1713638925 |
| Skewness | 14.15839184 |
| Sum | 79756 |
| Variance | 0.2871017016 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 828135 | 94.3% | |
| 1 | 37233 | 4.2% | |
| 2 | 7074 | 0.8% | |
| 3 | 2032 | 0.2% | |
| 4 | 1208 | 0.1% | |
| 5 | 661 | 0.1% | |
| 6 | 493 | 0.1% | |
| 7 | 308 | < 0.1% | |
| 8 | 230 | < 0.1% | |
| 9 | 171 | < 0.1% | |
| Other values (20) | 441 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 828135 | 94.3% | |
| 1 | 37233 | 4.2% | |
| 2 | 7074 | 0.8% | |
| 3 | 2032 | 0.2% | |
| 4 | 1208 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 30 | 2 | < 0.1% | |
| 29 | 1 | < 0.1% | |
| 26 | 1 | < 0.1% |
num_tl_op_past_12m
Numeric
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.129195682 |
|---|---|
| Minimum | 0 |
| Maximum | 32 |
| Zeros (%) | 18.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 32 |
| Range | 32 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.887244228 |
|---|---|
| Coef of variation | 0.8863648578 |
| Kurtosis | 4.866510133 |
| Mean | 2.129195682 |
| MAD | 1.420684558 |
| Skewness | 1.534759941 |
| Sum | 1869404 |
| Variance | 3.561690775 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 1 | 221442 | 25.2% | |
| 2 | 191442 | 21.8% | |
| 0 | 163858 | 18.7% | |
| 3 | 133569 | 15.2% | |
| 4 | 79041 | 9.0% | |
| 5 | 41617 | 4.7% | |
| 6 | 21479 | 2.4% | |
| 7 | 11988 | 1.4% | |
| 8 | 5930 | 0.7% | |
| 9 | 3279 | 0.4% | |
| Other values (23) | 4341 | 0.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 163858 | 18.7% | |
| 1 | 221442 | 25.2% | |
| 2 | 191442 | 21.8% | |
| 3 | 133569 | 15.2% | |
| 4 | 79041 | 9.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 32 | 1 | < 0.1% | |
| 31 | 1 | < 0.1% | |
| 30 | 1 | < 0.1% | |
| 29 | 1 | < 0.1% | |
| 28 | 4 | < 0.1% |
open_acc
Highly correlated
This variable is highly correlated with num_sats and should be ignored for analysis
| Correlation | 0.9988132903 |
|---|
out_prncp
Numeric
| Distinct count | 237959 |
|---|---|
| Unique (%) | 27.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5457.725306 |
|---|---|
| Minimum | 0 |
| Maximum | 38574.22 |
| Zeros (%) | 39.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2416.34 |
| Q3 | 8710.76 |
| 95-th percentile | 21123.9575 |
| Maximum | 38574.22 |
| Range | 38574.22 |
| Interquartile range | 8710.76 |
Descriptive statistics
| Standard deviation | 7174.495622 |
|---|---|
| Coef of variation | 1.314557846 |
| Kurtosis | 1.945575952 |
| Mean | 5457.725306 |
| MAD | 5622.233476 |
| Skewness | 1.545593957 |
| Sum | 4791806411 |
| Variance | 51473387.44 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 345363 | 39.3% | |
| 7237.84 | 193 | < 0.1% | |
| 1779.11 | 185 | < 0.1% | |
| 7498.9 | 169 | < 0.1% | |
| 7526.72 | 167 | < 0.1% | |
| 7512.78 | 166 | < 0.1% | |
| 3558.22 | 162 | < 0.1% | |
| 7456.78 | 160 | < 0.1% | |
| 6742.07 | 154 | < 0.1% | |
| 6475.96 | 151 | < 0.1% | |
| Other values (237949) | 531116 | 60.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 345363 | 39.3% | |
| 0.01 | 1 | < 0.1% | |
| 0.04 | 1 | < 0.1% | |
| 0.05 | 1 | < 0.1% | |
| 0.13 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 38574.22 | 1 | < 0.1% | |
| 37600 | 1 | < 0.1% | |
| 37540.29 | 1 | < 0.1% | |
| 37401.02 | 1 | < 0.1% | |
| 37340.86 | 1 | < 0.1% |
out_prncp_inv
Highly correlated
This variable is highly correlated with out_prncp and should be ignored for analysis
| Correlation | 0.9999980186 |
|---|
pct_tl_nvr_dlq
Numeric
| Distinct count | 649 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 93.6745726 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 74.1 |
| Q1 | 90.7 |
| Median | 97.6 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 9.3 |
Descriptive statistics
| Standard deviation | 9.457127757 |
|---|---|
| Coef of variation | 0.1009572555 |
| Kurtosis | 6.629980174 |
| Mean | 93.6745726 |
| MAD | 6.886355356 |
| Skewness | -2.235874594 |
| Sum | 82244963.3 |
| Variance | 89.4372654 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 100 | 425482 | 48.5% | |
| 90 | 11658 | 1.3% | |
| 90.9 | 10368 | 1.2% | |
| 91.7 | 10205 | 1.2% | |
| 88.9 | 10151 | 1.2% | |
| 92.3 | 9991 | 1.1% | |
| 87.5 | 9954 | 1.1% | |
| 85.7 | 9890 | 1.1% | |
| 95 | 9681 | 1.1% | |
| 92.9 | 9625 | 1.1% | |
| Other values (639) | 360981 | 41.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 6 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 5.9 | 1 | < 0.1% | |
| 6.7 | 1 | < 0.1% | |
| 7.1 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 425482 | 48.5% | |
| 99.4 | 2 | < 0.1% | |
| 99.3 | 1 | < 0.1% | |
| 99.2 | 4 | < 0.1% | |
| 99.1 | 8 | < 0.1% |
policy_code
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
pub_rec
Numeric
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2353146861 |
|---|---|
| Minimum | 0 |
| Maximum | 61 |
| Zeros (%) | 81.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6390593224 |
|---|---|
| Coef of variation | 2.715764719 |
| Kurtosis | 403.2757727 |
| Mean | 0.2353146861 |
| MAD | 0.3853422513 |
| Skewness | 9.445952551 |
| Sum | 206603 |
| Variance | 0.4083968176 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 718878 | 81.9% | |
| 1 | 131388 | 15.0% | |
| 2 | 17750 | 2.0% | |
| 3 | 5669 | 0.6% | |
| 4 | 2146 | 0.2% | |
| 5 | 1019 | 0.1% | |
| 6 | 518 | 0.1% | |
| 7 | 240 | < 0.1% | |
| 8 | 123 | < 0.1% | |
| 9 | 87 | < 0.1% | |
| Other values (25) | 168 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 718878 | 81.9% | |
| 1 | 131388 | 15.0% | |
| 2 | 17750 | 2.0% | |
| 3 | 5669 | 0.6% | |
| 4 | 2146 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 61 | 2 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 46 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 44 | 1 | < 0.1% |
pub_rec_bankruptcies
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1398530273 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 87.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.3850018638 |
|---|---|
| Coef of variation | 2.752903325 |
| Kurtosis | 17.72890192 |
| Mean | 0.1398530273 |
| MAD | 0.2434774899 |
| Skewness | 3.333164487 |
| Sum | 122789 |
| Variance | 0.1482264351 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 764266 | 87.0% | |
| 1 | 106867 | 12.2% | |
| 2 | 5303 | 0.6% | |
| 3 | 1102 | 0.1% | |
| 4 | 297 | < 0.1% | |
| 5 | 103 | < 0.1% | |
| 6 | 35 | < 0.1% | |
| 7 | 8 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 9 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 764266 | 87.0% | |
| 1 | 106867 | 12.2% | |
| 2 | 5303 | 0.6% | |
| 3 | 1102 | 0.1% | |
| 4 | 297 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 7 | 8 | < 0.1% | |
| 6 | 35 | < 0.1% | |
| 5 | 103 | < 0.1% |
purpose
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| debt_consolidation | |
|---|---|
| credit_card | |
| home_improvement | 65875 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| debt_consolidation | 493982 | 56.3% | |
| credit_card | 183075 | 20.9% | |
| home_improvement | 65875 | 7.5% | |
| other | 61526 | 7.0% | |
| major_purchase | 21546 | 2.5% | |
| medical | 12325 | 1.4% | |
| car | 10170 | 1.2% | |
| small_business | 9728 | 1.1% | |
| vacation | 7288 | 0.8% | |
| moving | 6873 | 0.8% | |
| Other values (4) | 5598 | 0.6% |
| Max length | 18 |
|---|---|
| Mean length | 14.75631844 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
pymnt_plan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| n | |
|---|---|
| y | 676 |
| Value | Count | Frequency (%) | |
| n | 877310 | 99.9% | |
| y | 676 | 0.1% |
recoveries
Highly correlated
This variable is highly correlated with collection_recovery_fee and should be ignored for analysis
| Correlation | 0.9864791705 |
|---|
revol_bal
Numeric
| Distinct count | 76815 |
|---|---|
| Unique (%) | 8.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16612.13533 |
|---|---|
| Minimum | 0 |
| Maximum | 2559552 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1559 |
| Q1 | 5810 |
| Median | 11036 |
| Q3 | 19844 |
| 95-th percentile | 45786 |
| Maximum | 2559552 |
| Range | 2559552 |
| Interquartile range | 14034 |
Descriptive statistics
| Standard deviation | 23524.60924 |
|---|---|
| Coef of variation | 1.416109896 |
| Kurtosis | 369.6307028 |
| Mean | 16612.13533 |
| MAD | 11939.00591 |
| Skewness | 10.84383952 |
| Sum | 1.458522225e+10 |
| Variance | 553407239.7 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 4418 | 0.5% | |
| 8 | 98 | < 0.1% | |
| 10 | 74 | < 0.1% | |
| 5262 | 73 | < 0.1% | |
| 5453 | 72 | < 0.1% | |
| 5125 | 71 | < 0.1% | |
| 2 | 70 | < 0.1% | |
| 5724 | 70 | < 0.1% | |
| 5723 | 69 | < 0.1% | |
| 4327 | 69 | < 0.1% | |
| Other values (76805) | 872902 | 99.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4418 | 0.5% | |
| 1 | 39 | < 0.1% | |
| 2 | 70 | < 0.1% | |
| 3 | 53 | < 0.1% | |
| 4 | 57 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2559552 | 1 | < 0.1% | |
| 1698749 | 1 | < 0.1% | |
| 1696796 | 1 | < 0.1% | |
| 1087664 | 1 | < 0.1% | |
| 1044210 | 1 | < 0.1% |
sub_grade
Categorical
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| C1 | 64118 |
|---|---|
| B5 | 62555 |
| C4 | 54134 |
| Other values (32) |
| Value | Count | Frequency (%) | |
| C1 | 64118 | 7.3% | |
| B5 | 62555 | 7.1% | |
| C4 | 54134 | 6.2% | |
| C2 | 53682 | 6.1% | |
| C3 | 52744 | 6.0% | |
| C5 | 52644 | 6.0% | |
| B4 | 52436 | 6.0% | |
| B1 | 52329 | 6.0% | |
| B3 | 52011 | 5.9% | |
| B2 | 48308 | 5.5% | |
| Other values (25) | 333025 | 37.9% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
tax_liens
Numeric
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.06532792095 |
|---|---|
| Minimum | 0 |
| Maximum | 61 |
| Zeros (%) | 96.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.4409775114 |
|---|---|
| Coef of variation | 6.750214992 |
| Kurtosis | 1697.49851 |
| Mean | 0.06532792095 |
| MAD | 0.1254597339 |
| Skewness | 23.34781072 |
| Sum | 57357 |
| Variance | 0.1944611656 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 843069 | 96.0% | |
| 1 | 23465 | 2.7% | |
| 2 | 6612 | 0.8% | |
| 3 | 2455 | 0.3% | |
| 4 | 1090 | 0.1% | |
| 5 | 573 | 0.1% | |
| 6 | 289 | < 0.1% | |
| 7 | 146 | < 0.1% | |
| 8 | 97 | < 0.1% | |
| 9 | 55 | < 0.1% | |
| Other values (24) | 135 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 843069 | 96.0% | |
| 1 | 23465 | 2.7% | |
| 2 | 6612 | 0.8% | |
| 3 | 2455 | 0.3% | |
| 4 | 1090 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 61 | 2 | < 0.1% | |
| 46 | 1 | < 0.1% | |
| 45 | 2 | < 0.1% | |
| 44 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% |
term
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 36 months | |
|---|---|
| 60 months |
| Value | Count | Frequency (%) | |
| 36 months | 643914 | 73.3% | |
| 60 months | 234072 | 26.7% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
tot_coll_amt
Numeric
| Distinct count | 11174 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 249.6479727 |
|---|---|
| Minimum | 0 |
| Maximum | 932461 |
| Zeros (%) | 83.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 942 |
| Maximum | 932461 |
| Range | 932461 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 2313.7487 |
|---|---|
| Coef of variation | 9.268045216 |
| Kurtosis | 51943.77326 |
| Mean | 249.6479727 |
| MAD | 430.3873227 |
| Skewness | 151.083683 |
| Sum | 219187425 |
| Variance | 5353433.045 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 729825 | 83.1% | |
| 50 | 1578 | 0.2% | |
| 100 | 1326 | 0.2% | |
| 75 | 1030 | 0.1% | |
| 200 | 848 | 0.1% | |
| 150 | 833 | 0.1% | |
| 60 | 776 | 0.1% | |
| 70 | 587 | 0.1% | |
| 80 | 584 | 0.1% | |
| 250 | 537 | 0.1% | |
| Other values (11164) | 140062 | 16.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 729825 | 83.1% | |
| 2 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 7 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 932461 | 1 | < 0.1% | |
| 848438 | 1 | < 0.1% | |
| 309838 | 1 | < 0.1% | |
| 262740 | 1 | < 0.1% | |
| 224107 | 1 | < 0.1% |
tot_cur_bal
Numeric
| Distinct count | 345595 |
|---|---|
| Unique (%) | 39.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 144489.7479 |
|---|---|
| Minimum | 0 |
| Maximum | 8524709 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8405 |
| Q1 | 29598 |
| Median | 80675.5 |
| Q3 | 215655 |
| 95-th percentile | 447590.75 |
| Maximum | 8524709 |
| Range | 8524709 |
| Interquartile range | 186057 |
Descriptive statistics
| Standard deviation | 163040.8928 |
|---|---|
| Coef of variation | 1.128390734 |
| Kurtosis | 27.55432988 |
| Mean | 144489.7479 |
| MAD | 120051.5081 |
| Skewness | 2.890798826 |
| Sum | 1.268599758e+11 |
| Variance | 2.658233271e+10 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 258 | < 0.1% | |
| 12794 | 22 | < 0.1% | |
| 23520 | 21 | < 0.1% | |
| 25344 | 21 | < 0.1% | |
| 22373 | 20 | < 0.1% | |
| 24830 | 20 | < 0.1% | |
| 16053 | 20 | < 0.1% | |
| 28171 | 20 | < 0.1% | |
| 18837 | 19 | < 0.1% | |
| 20084 | 19 | < 0.1% | |
| Other values (345585) | 877546 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 258 | < 0.1% | |
| 1 | 7 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 3 | 7 | < 0.1% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8524709 | 1 | < 0.1% | |
| 5445012 | 1 | < 0.1% | |
| 5172185 | 1 | < 0.1% | |
| 4348538 | 1 | < 0.1% | |
| 4035706 | 1 | < 0.1% |
tot_hi_cred_lim
Highly correlated
This variable is highly correlated with tot_cur_bal and should be ignored for analysis
| Correlation | 0.972754613 |
|---|
total_acc
Numeric
| Distinct count | 135 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 23.91298836 |
|---|---|
| Minimum | 2 |
| Maximum | 176 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 15 |
| Median | 22 |
| Q3 | 30 |
| 95-th percentile | 46 |
| Maximum | 176 |
| Range | 174 |
| Interquartile range | 15 |
Descriptive statistics
| Standard deviation | 11.95948862 |
|---|---|
| Coef of variation | 0.5001252224 |
| Kurtosis | 2.160655547 |
| Mean | 23.91298836 |
| MAD | 9.286471479 |
| Skewness | 1.071604412 |
| Sum | 20995269 |
| Variance | 143.0293681 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 20 | 32534 | 3.7% | |
| 18 | 32445 | 3.7% | |
| 19 | 32366 | 3.7% | |
| 17 | 32079 | 3.7% | |
| 21 | 31992 | 3.6% | |
| 16 | 31849 | 3.6% | |
| 22 | 30842 | 3.5% | |
| 15 | 30754 | 3.5% | |
| 23 | 30424 | 3.5% | |
| 14 | 29719 | 3.4% | |
| Other values (125) | 562982 | 64.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 508 | 0.1% | |
| 3 | 1685 | 0.2% | |
| 4 | 3882 | 0.4% | |
| 5 | 6346 | 0.7% | |
| 6 | 9505 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 176 | 1 | < 0.1% | |
| 173 | 1 | < 0.1% | |
| 165 | 1 | < 0.1% | |
| 160 | 1 | < 0.1% | |
| 157 | 1 | < 0.1% |
total_bal_ex_mort
Numeric
| Distinct count | 166421 |
|---|---|
| Unique (%) | 19.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 52322.54494 |
|---|---|
| Minimum | 0 |
| Maximum | 3408095 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6702 |
| Q1 | 21366 |
| Median | 38701 |
| Q3 | 66090 |
| 95-th percentile | 142814.75 |
| Maximum | 3408095 |
| Range | 3408095 |
| Interquartile range | 44724 |
Descriptive statistics
| Standard deviation | 50905.60351 |
|---|---|
| Coef of variation | 0.9729191033 |
| Kurtosis | 54.70301751 |
| Mean | 52322.54494 |
| MAD | 33402.83465 |
| Skewness | 3.901526222 |
| Sum | 4.593846194e+10 |
| Variance | 2591380468 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 485 | 0.1% | |
| 27673 | 30 | < 0.1% | |
| 23915 | 30 | < 0.1% | |
| 12794 | 28 | < 0.1% | |
| 18720 | 28 | < 0.1% | |
| 21641 | 28 | < 0.1% | |
| 23366 | 27 | < 0.1% | |
| 24830 | 27 | < 0.1% | |
| 22702 | 27 | < 0.1% | |
| 28739 | 27 | < 0.1% | |
| Other values (166411) | 877249 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 485 | 0.1% | |
| 1 | 11 | < 0.1% | |
| 2 | 8 | < 0.1% | |
| 3 | 11 | < 0.1% | |
| 4 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3408095 | 1 | < 0.1% | |
| 2698600 | 1 | < 0.1% | |
| 1771306 | 1 | < 0.1% | |
| 1548128 | 1 | < 0.1% | |
| 1501187 | 1 | < 0.1% |
total_bc_limit
Numeric
| Distinct count | 8349 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 23277.08784 |
|---|---|
| Minimum | 0 |
| Maximum | 1105500 |
| Zeros (%) | 1.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2300 |
| Q1 | 8400 |
| Median | 16400 |
| Q3 | 30400 |
| 95-th percentile | 67400 |
| Maximum | 1105500 |
| Range | 1105500 |
| Interquartile range | 22000 |
Descriptive statistics
| Standard deviation | 23079.52043 |
|---|---|
| Coef of variation | 0.9915123654 |
| Kurtosis | 21.59122619 |
| Mean | 23277.08784 |
| MAD | 15963.72434 |
| Skewness | 2.900655075 |
| Sum | 2.043695724e+10 |
| Variance | 532664263.1 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 10424 | 1.2% | |
| 5000 | 6913 | 0.8% | |
| 6000 | 6163 | 0.7% | |
| 10000 | 6156 | 0.7% | |
| 7000 | 5896 | 0.7% | |
| 8000 | 5779 | 0.7% | |
| 4000 | 5624 | 0.6% | |
| 3000 | 5499 | 0.6% | |
| 9000 | 5430 | 0.6% | |
| 7500 | 5402 | 0.6% | |
| Other values (8339) | 814700 | 92.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 10424 | 1.2% | |
| 100 | 5 | < 0.1% | |
| 200 | 108 | < 0.1% | |
| 250 | 2 | < 0.1% | |
| 251 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1105500 | 1 | < 0.1% | |
| 719500 | 1 | < 0.1% | |
| 711400 | 1 | < 0.1% | |
| 616000 | 1 | < 0.1% | |
| 520500 | 1 | < 0.1% |
total_il_high_credit_limit
Numeric
| Distinct count | 152973 |
|---|---|
| Unique (%) | 17.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 45490.25168 |
|---|---|
| Minimum | 0 |
| Maximum | 2000000 |
| Zeros (%) | 10.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 16122 |
| Median | 34265 |
| Q3 | 60960.75 |
| 95-th percentile | 128951 |
| Maximum | 2000000 |
| Range | 2000000 |
| Interquartile range | 44838.75 |
Descriptive statistics
| Standard deviation | 45931.62248 |
|---|---|
| Coef of variation | 1.009702536 |
| Kurtosis | 25.34514141 |
| Mean | 45490.25168 |
| MAD | 31569.8116 |
| Skewness | 3.024418596 |
| Sum | 3.993980412e+10 |
| Variance | 2109713944 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 94263 | 10.7% | |
| 10000 | 5578 | 0.6% | |
| 15000 | 4432 | 0.5% | |
| 20000 | 3728 | 0.4% | |
| 5000 | 3519 | 0.4% | |
| 12000 | 2868 | 0.3% | |
| 25000 | 2620 | 0.3% | |
| 6000 | 2327 | 0.3% | |
| 8000 | 2270 | 0.3% | |
| 7000 | 1496 | 0.2% | |
| Other values (152963) | 754885 | 86.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 94263 | 10.7% | |
| 36 | 1 | < 0.1% | |
| 44 | 1 | < 0.1% | |
| 75 | 1 | < 0.1% | |
| 95 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2000000 | 1 | < 0.1% | |
| 1736064 | 1 | < 0.1% | |
| 1349413 | 1 | < 0.1% | |
| 1310923 | 1 | < 0.1% | |
| 1285625 | 1 | < 0.1% |
total_pymnt
Numeric
| Distinct count | 606059 |
|---|---|
| Unique (%) | 69.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 10444.12374 |
|---|---|
| Minimum | 0 |
| Maximum | 59808.26209 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1722.64 |
| Q1 | 4416.04 |
| Median | 7955.52 |
| Q3 | 13866.1625 |
| 95-th percentile | 28047.28842 |
| Maximum | 59808.26209 |
| Range | 59808.26209 |
| Interquartile range | 9450.1225 |
Descriptive statistics
| Standard deviation | 8409.701654 |
|---|---|
| Coef of variation | 0.8052089255 |
| Kurtosis | 2.404868468 |
| Mean | 10444.12374 |
| MAD | 6363.453108 |
| Skewness | 1.532553823 |
| Sum | 9169794425 |
| Variance | 70723081.91 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 392 | < 0.1% | |
| 9031.54 | 110 | < 0.1% | |
| 3515.31 | 108 | < 0.1% | |
| 4642.74 | 96 | < 0.1% | |
| 3127.87 | 94 | < 0.1% | |
| 3590.61 | 94 | < 0.1% | |
| 18063.09 | 92 | < 0.1% | |
| 3646.44 | 92 | < 0.1% | |
| 3441.1 | 89 | < 0.1% | |
| 9028.59 | 88 | < 0.1% | |
| Other values (606049) | 876731 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 392 | < 0.1% | |
| 16.58 | 1 | < 0.1% | |
| 17.58 | 1 | < 0.1% | |
| 30.7 | 1 | < 0.1% | |
| 33.63 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 59808.26209 | 1 | < 0.1% | |
| 58559.128 | 1 | < 0.1% | |
| 57459.75603 | 1 | < 0.1% | |
| 56642.01229 | 1 | < 0.1% | |
| 56109.34 | 1 | < 0.1% |
total_pymnt_inv
Highly correlated
This variable is highly correlated with total_pymnt and should be ignored for analysis
| Correlation | 0.9999946425 |
|---|
total_rec_int
Numeric
| Distinct count | 373667 |
|---|---|
| Unique (%) | 42.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2168.23948 |
|---|---|
| Minimum | 0 |
| Maximum | 22644.05 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 202.66 |
| Q1 | 715.9225 |
| Median | 1470.505 |
| Q3 | 2887.845 |
| 95-th percentile | 6455.6475 |
| Maximum | 22644.05 |
| Range | 22644.05 |
| Interquartile range | 2171.9225 |
Descriptive statistics
| Standard deviation | 2157.487331 |
|---|---|
| Coef of variation | 0.9950410697 |
| Kurtosis | 7.160820834 |
| Mean | 2168.23948 |
| MAD | 1548.358239 |
| Skewness | 2.222608116 |
| Sum | 1903683908 |
| Variance | 4654751.585 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 1236 | 0.1% | |
| 960.93 | 123 | < 0.1% | |
| 753.15 | 107 | < 0.1% | |
| 810.65 | 102 | < 0.1% | |
| 872.71 | 98 | < 0.1% | |
| 972.78 | 94 | < 0.1% | |
| 634.17 | 92 | < 0.1% | |
| 584.65 | 92 | < 0.1% | |
| 1621.31 | 90 | < 0.1% | |
| 1104.51 | 82 | < 0.1% | |
| Other values (373657) | 875870 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1236 | 0.1% | |
| 0.01 | 16 | < 0.1% | |
| 0.07 | 2 | < 0.1% | |
| 0.12 | 1 | < 0.1% | |
| 0.19 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22644.05 | 1 | < 0.1% | |
| 22559.92 | 1 | < 0.1% | |
| 22117.12 | 1 | < 0.1% | |
| 22088.55 | 1 | < 0.1% | |
| 21997.72 | 1 | < 0.1% |
total_rec_late_fee
Numeric
| Distinct count | 7058 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.536038639 |
|---|---|
| Minimum | -3.9e-09 |
| Maximum | 1198.89 |
| Zeros (%) | 96.2% |
Quantile statistics
| Minimum | -3.9e-09 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1198.89 |
| Range | 1198.89 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 11.85547305 |
|---|---|
| Coef of variation | 7.718212781 |
| Kurtosis | 815.3171504 |
| Mean | 1.536038639 |
| MAD | 2.954951753 |
| Skewness | 20.29350981 |
| Sum | 1348620.42 |
| Variance | 140.5522413 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 0 | 844499 | 96.2% | |
| 15 | 8178 | 0.9% | |
| 30 | 1677 | 0.2% | |
| 45 | 548 | 0.1% | |
| 60 | 249 | < 0.1% | |
| 75 | 124 | < 0.1% | |
| 16.49 | 72 | < 0.1% | |
| 15.00000001 | 66 | < 0.1% | |
| 16.61 | 63 | < 0.1% | |
| 19.78 | 58 | < 0.1% | |
| Other values (7048) | 22452 | 2.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -3.9e-09 | 1 | < 0.1% | |
| -2e-09 | 1 | < 0.1% | |
| -4e-10 | 1 | < 0.1% | |
| 0 | 844499 | 96.2% | |
| 3e-10 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1198.89 | 1 | < 0.1% | |
| 1188.83 | 1 | < 0.1% | |
| 883.31 | 1 | < 0.1% | |
| 801.6 | 1 | < 0.1% | |
| 765 | 1 | < 0.1% |
total_rec_prncp
Highly correlated
This variable is highly correlated with total_pymnt_inv and should be ignored for analysis
| Correlation | 0.9665829516 |
|---|
total_rev_hi_lim
Numeric
| Distinct count | 17911 |
|---|---|
| Unique (%) | 2.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 34778.91482 |
|---|---|
| Minimum | 0 |
| Maximum | 2175000 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5900 |
| Q1 | 14600 |
| Median | 25500 |
| Q3 | 43300 |
| 95-th percentile | 92000 |
| Maximum | 2175000 |
| Range | 2175000 |
| Interquartile range | 28700 |
Descriptive statistics
| Standard deviation | 35445.19158 |
|---|---|
| Coef of variation | 1.019157492 |
| Kurtosis | 99.81228952 |
| Mean | 34778.91482 |
| MAD | 21788.39337 |
| Skewness | 5.771171984 |
| Sum | 3.05354003e+10 |
| Variance | 1256361606 |
| Memory size | 6.7 MiB |
| Value | Count | Frequency (%) | |
| 10000 | 2959 | 0.3% | |
| 11000 | 2734 | 0.3% | |
| 14000 | 2731 | 0.3% | |
| 15000 | 2718 | 0.3% | |
| 13000 | 2711 | 0.3% | |
| 11500 | 2701 | 0.3% | |
| 16000 | 2682 | 0.3% | |
| 12000 | 2681 | 0.3% | |
| 12500 | 2627 | 0.3% | |
| 14500 | 2612 | 0.3% | |
| Other values (17901) | 850830 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 584 | 0.1% | |
| 100 | 12 | < 0.1% | |
| 200 | 25 | < 0.1% | |
| 300 | 140 | < 0.1% | |
| 400 | 48 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2175000 | 1 | < 0.1% | |
| 1827401 | 1 | < 0.1% | |
| 1652700 | 1 | < 0.1% | |
| 1649101 | 1 | < 0.1% | |
| 1629000 | 1 | < 0.1% |
verification_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Source Verified | |
|---|---|
| Not Verified | |
| Verified |
| Value | Count | Frequency (%) | |
| Source Verified | 352959 | 40.2% | |
| Not Verified | 285462 | 32.5% | |
| Verified | 239565 | 27.3% |
| Max length | 15 |
|---|---|
| Mean length | 12.11459978 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
First rows
| acc_now_delinq | acc_open_past_24mths | addr_state | annual_inc | application_type | chargeoff_within_12_mths | collection_recovery_fee | collections_12_mths_ex_med | debt_settlement_flag | delinq_2yrs | delinq_amnt | df_index | disbursement_method | earliest_cr_line | fico_range_high | fico_range_low | funded_amnt | funded_amnt_inv | grade | hardship_flag | home_ownership | initial_list_status | installment | int_rate | issue_d | last_fico_range_high | last_fico_range_low | last_pymnt_amnt | loan_amnt | loan_status | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | open_acc | out_prncp | out_prncp_inv | pct_tl_nvr_dlq | policy_code | pub_rec | pub_rec_bankruptcies | purpose | pymnt_plan | recoveries | revol_bal | sub_grade | tax_liens | term | tot_coll_amt | tot_cur_bal | tot_hi_cred_lim | total_acc | total_bal_ex_mort | total_bc_limit | total_il_high_credit_limit | total_pymnt | total_pymnt_inv | total_rec_int | total_rec_late_fee | total_rec_prncp | total_rev_hi_lim | verification_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 6 | IN | 108329.0 | Individual | 0 | 0.0000 | 0 | N | 1 | 0 | 0 | Cash | Mar-96 | 699 | 695 | 26000 | 26000.0 | C | N | RENT | w | 894.82 | 14.49 | Sep-16 | 669 | 665 | 894.82 | 26000 | Current | 246 | 6 | 6 | 0 | 0 | 4 | 8 | 5 | 6 | 11 | 14 | 19 | 8 | 21 | 0 | 0 | 4 | 21 | 9968.30 | 9968.30 | 89.7 | 1 | 0 | 0 | car | n | 0.00 | 12300 | C4 | 0 | 36 months | 0 | 56283 | 126593 | 30 | 56283 | 18200 | 93993 | 21523.300000 | 21523.30 | 5402.12 | 89.48 | 16031.70 | 32600 | Not Verified |
| 1 | 0 | 4 | FL | 75000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 1 | Cash | Apr-86 | 799 | 795 | 12000 | 12000.0 | A | N | MORTGAGE | f | 361.38 | 5.32 | Sep-16 | 809 | 805 | 10533.60 | 12000 | Fully Paid | 365 | 13 | 13 | 7 | 0 | 7 | 7 | 12 | 15 | 5 | 15 | 21 | 7 | 20 | 0 | 0 | 0 | 20 | 0.00 | 0.00 | 100.0 | 1 | 0 | 0 | home_improvement | n | 0.00 | 19897 | A1 | 0 | 36 months | 0 | 242695 | 486000 | 33 | 37584 | 153700 | 39000 | 12333.411430 | 12333.41 | 333.41 | 0.00 | 12000.00 | 167000 | Not Verified |
| 2 | 0 | 8 | TX | 56000.0 | Individual | 0 | 228.7458 | 0 | Y | 0 | 0 | 2 | Cash | Sep-03 | 674 | 670 | 3000 | 3000.0 | C | N | MORTGAGE | w | 102.52 | 13.99 | Sep-16 | 629 | 625 | 102.52 | 3000 | Charged Off | 133 | 3 | 3 | 2 | 0 | 2 | 4 | 2 | 2 | 5 | 5 | 6 | 4 | 9 | 0 | 0 | 3 | 9 | 0.00 | 0.00 | 100.0 | 1 | 1 | 1 | debt_consolidation | n | 1270.81 | 5466 | C3 | 0 | 36 months | 0 | 99733 | 112925 | 13 | 22032 | 2700 | 27025 | 1778.750000 | 1778.75 | 162.25 | 0.00 | 345.69 | 5900 | Source Verified |
| 3 | 0 | 3 | NC | 110000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 3 | Cash | Oct-77 | 704 | 700 | 8000 | 8000.0 | A | N | MORTGAGE | f | 249.19 | 7.59 | Sep-16 | 744 | 740 | 284.19 | 8000 | Current | 467 | 9 | 9 | 1 | 3 | 10 | 13 | 11 | 19 | 7 | 19 | 40 | 13 | 22 | 0 | 0 | 3 | 22 | 2206.31 | 2206.31 | 89.6 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 46404 | A3 | 0 | 36 months | 0 | 257939 | 365263 | 48 | 55664 | 56300 | 19763 | 6594.620000 | 6594.62 | 800.93 | 0.00 | 5793.69 | 75500 | Source Verified |
| 4 | 0 | 4 | IL | 75000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 4 | Cash | Apr-08 | 664 | 660 | 18000 | 18000.0 | C | N | RENT | w | 423.42 | 14.49 | Sep-16 | 509 | 505 | 423.42 | 18000 | Charged Off | 32 | 5 | 5 | 0 | 0 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 0 | 0 | 1 | 5 | 0.00 | 0.00 | 85.7 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 6469 | C4 | 0 | 60 months | 0 | 15803 | 26627 | 7 | 15803 | 12700 | 12827 | 5475.480000 | 5475.48 | 2593.62 | 0.00 | 2881.86 | 13800 | Not Verified |
| 5 | 0 | 5 | CA | 65000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 5 | Cash | Nov-92 | 704 | 700 | 32200 | 32200.0 | D | N | MORTGAGE | w | 880.02 | 21.49 | Sep-16 | 734 | 730 | 31447.60 | 32200 | Fully Paid | 286 | 3 | 3 | 3 | 0 | 3 | 5 | 5 | 10 | 7 | 14 | 24 | 5 | 17 | 0 | 0 | 2 | 17 | 0.00 | 0.00 | 100.0 | 1 | 1 | 1 | credit_card | n | 0.00 | 11987 | D5 | 0 | 60 months | 0 | 173513 | 199969 | 34 | 24934 | 13900 | 15886 | 35770.812750 | 35770.81 | 3570.81 | 0.00 | 32200.00 | 24900 | Not Verified |
| 6 | 0 | 3 | OR | 35000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 6 | Cash | Sep-09 | 774 | 770 | 2600 | 2600.0 | B | N | RENT | w | 82.67 | 8.99 | Sep-16 | 764 | 760 | 2492.06 | 2600 | Fully Paid | 61 | 13 | 13 | 0 | 0 | 4 | 5 | 6 | 8 | 14 | 7 | 10 | 5 | 14 | 0 | 0 | 0 | 14 | 0.00 | 0.00 | 100.0 | 1 | 0 | 0 | moving | n | 0.00 | 720 | B1 | 0 | 36 months | 0 | 19497 | 73227 | 24 | 19497 | 50200 | 20527 | 2662.590238 | 2662.59 | 62.59 | 0.00 | 2600.00 | 52700 | Source Verified |
| 7 | 0 | 7 | OK | 65000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 7 | Cash | Jul-04 | 709 | 705 | 1000 | 1000.0 | C | N | OWN | w | 33.94 | 13.49 | Sep-16 | 699 | 695 | 820.22 | 1000 | Fully Paid | 146 | 4 | 4 | 2 | 0 | 3 | 3 | 5 | 6 | 8 | 6 | 11 | 3 | 9 | 0 | 0 | 4 | 9 | 0.00 | 0.00 | 100.0 | 1 | 0 | 0 | other | n | 0.00 | 12501 | C2 | 0 | 36 months | 78 | 109761 | 131469 | 21 | 23568 | 29100 | 13000 | 1090.243921 | 1090.24 | 90.24 | 0.00 | 1000.00 | 30100 | Verified |
| 8 | 0 | 11 | OR | 60000.0 | Individual | 0 | 0.0000 | 0 | N | 2 | 0 | 8 | Cash | Sep-98 | 699 | 695 | 12000 | 12000.0 | D | N | MORTGAGE | w | 311.23 | 18.99 | Sep-16 | 714 | 710 | 12107.09 | 12000 | Fully Paid | 216 | 4 | 1 | 8 | 1 | 2 | 8 | 5 | 9 | 6 | 17 | 23 | 8 | 19 | 0 | 2 | 9 | 19 | 0.00 | 0.00 | 78.4 | 1 | 0 | 0 | major_purchase | n | 0.00 | 7935 | D3 | 0 | 60 months | 0 | 272439 | 290671 | 37 | 43438 | 11000 | 35386 | 12704.232870 | 12704.23 | 704.23 | 0.00 | 12000.00 | 21600 | Not Verified |
| 9 | 0 | 8 | IL | 95000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 9 | Cash | May-93 | 674 | 670 | 8000 | 8000.0 | C | N | MORTGAGE | w | 268.75 | 12.79 | Sep-16 | 644 | 640 | 268.75 | 8000 | Current | 280 | 6 | 2 | 3 | 0 | 3 | 8 | 4 | 6 | 8 | 10 | 19 | 8 | 12 | 0 | 0 | 7 | 12 | 3023.53 | 3023.53 | 96.4 | 1 | 1 | 1 | debt_consolidation | n | 0.00 | 11343 | C1 | 0 | 36 months | 0 | 30705 | 44176 | 30 | 30705 | 15000 | 20476 | 6446.680000 | 6446.68 | 1470.21 | 0.00 | 4976.47 | 23700 | Verified |
Last rows
| acc_now_delinq | acc_open_past_24mths | addr_state | annual_inc | application_type | chargeoff_within_12_mths | collection_recovery_fee | collections_12_mths_ex_med | debt_settlement_flag | delinq_2yrs | delinq_amnt | df_index | disbursement_method | earliest_cr_line | fico_range_high | fico_range_low | funded_amnt | funded_amnt_inv | grade | hardship_flag | home_ownership | initial_list_status | installment | int_rate | issue_d | last_fico_range_high | last_fico_range_low | last_pymnt_amnt | loan_amnt | loan_status | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | open_acc | out_prncp | out_prncp_inv | pct_tl_nvr_dlq | policy_code | pub_rec | pub_rec_bankruptcies | purpose | pymnt_plan | recoveries | revol_bal | sub_grade | tax_liens | term | tot_coll_amt | tot_cur_bal | tot_hi_cred_lim | total_acc | total_bal_ex_mort | total_bc_limit | total_il_high_credit_limit | total_pymnt | total_pymnt_inv | total_rec_int | total_rec_late_fee | total_rec_prncp | total_rev_hi_lim | verification_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 877976 | 0 | 4 | OR | 60000.0 | Individual | 0 | 0.0000 | 0 | N | 1 | 0 | 97844 | Cash | Jun-97 | 684 | 680 | 19600 | 19600.0 | B | N | MORTGAGE | w | 430.76 | 11.47 | Apr-16 | 689 | 685 | 430.76 | 19600 | Current | 225 | 24 | 23 | 5 | 0 | 6 | 7 | 7 | 10 | 24 | 10 | 20 | 7 | 14 | 0 | 0 | 0 | 14 | 11188.99 | 11188.99 | 98.0 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 22358 | B5 | 0 | 60 months | 0 | 228358 | 280001 | 49 | 76160 | 17500 | 72841 | 12979.000000 | 12979.00 | 4567.99 | 0.0 | 8411.01 | 29700 | Not Verified |
| 877977 | 0 | 5 | CA | 139000.0 | Individual | 0 | 511.0074 | 0 | N | 0 | 0 | 97845 | Cash | Oct-03 | 664 | 660 | 28000 | 28000.0 | G | N | MORTGAGE | w | 883.16 | 28.67 | Apr-16 | 674 | 670 | 883.16 | 28000 | Charged Off | 86 | 9 | 5 | 1 | 3 | 2 | 3 | 2 | 5 | 5 | 5 | 9 | 3 | 8 | 0 | 0 | 3 | 8 | 0.00 | 0.00 | 78.6 | 1 | 0 | 0 | credit_card | n | 2838.93 | 3777 | G4 | 0 | 60 months | 1345 | 315577 | 359339 | 15 | 128115 | 5000 | 130782 | 10742.770000 | 10742.77 | 5781.23 | 0.0 | 2122.61 | 21700 | Not Verified |
| 877978 | 0 | 9 | VA | 59000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97846 | Cash | Aug-93 | 709 | 705 | 22400 | 22400.0 | G | N | RENT | w | 702.05 | 28.34 | Apr-16 | 694 | 690 | 702.05 | 22400 | Current | 271 | 4 | 4 | 0 | 0 | 2 | 11 | 2 | 9 | 11 | 14 | 29 | 11 | 16 | 0 | 0 | 7 | 16 | 15308.97 | 15308.97 | 100.0 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 93022 | G3 | 0 | 60 months | 0 | 121963 | 147496 | 40 | 121963 | 10100 | 42996 | 20324.180000 | 20324.18 | 13233.15 | 0.0 | 7091.03 | 104500 | Source Verified |
| 877979 | 0 | 8 | NY | 57900.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97847 | Cash | Nov-05 | 674 | 670 | 13350 | 13350.0 | G | N | RENT | w | 418.41 | 28.34 | Apr-16 | 559 | 555 | 418.41 | 13350 | Current | 91 | 8 | 8 | 0 | 0 | 5 | 9 | 7 | 10 | 16 | 13 | 17 | 9 | 24 | 0 | 0 | 3 | 24 | 9142.76 | 9142.76 | 71.0 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 9762 | G3 | 0 | 60 months | 0 | 93545 | 88750 | 33 | 93545 | 11300 | 67950 | 12222.020000 | 12222.02 | 8014.78 | 0.0 | 4207.24 | 20800 | Not Verified |
| 877980 | 0 | 4 | PA | 67000.0 | Individual | 0 | 0.0000 | 0 | N | 6 | 0 | 97848 | Cash | Apr-91 | 669 | 665 | 5000 | 5000.0 | B | N | OWN | w | 157.59 | 8.39 | Apr-16 | 654 | 650 | 157.59 | 5000 | Current | 299 | 2 | 2 | 1 | 0 | 6 | 7 | 8 | 11 | 12 | 14 | 23 | 7 | 16 | 0 | 0 | 1 | 16 | 922.55 | 922.55 | 68.6 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 10524 | B1 | 0 | 36 months | 170 | 27029 | 63658 | 36 | 27029 | 29800 | 27458 | 4725.370000 | 4725.37 | 647.92 | 0.0 | 4077.45 | 36200 | Not Verified |
| 877981 | 0 | 6 | IN | 45000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97849 | Cash | Apr-84 | 689 | 685 | 7000 | 7000.0 | A | N | MORTGAGE | w | 210.81 | 5.32 | Apr-16 | 709 | 705 | 210.81 | 7000 | Current | 383 | 16 | 6 | 3 | 2 | 3 | 5 | 3 | 12 | 5 | 8 | 26 | 5 | 9 | 0 | 0 | 2 | 9 | 1449.88 | 1449.88 | 68.6 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 5307 | A1 | 0 | 36 months | 0 | 72196 | 80800 | 35 | 5307 | 9700 | 0 | 6122.790000 | 6122.79 | 572.67 | 0.0 | 5550.12 | 13600 | Source Verified |
| 877982 | 0 | 8 | IN | 48000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97850 | Cash | Jul-04 | 699 | 695 | 21475 | 21475.0 | D | N | MORTGAGE | w | 536.84 | 17.27 | Apr-16 | 544 | 540 | 536.84 | 21475 | Charged Off | 140 | 3 | 3 | 1 | 0 | 5 | 5 | 8 | 9 | 8 | 15 | 18 | 5 | 17 | 0 | 0 | 3 | 17 | 0.00 | 0.00 | 100.0 | 1 | 1 | 1 | debt_consolidation | n | 0.00 | 17496 | D2 | 0 | 60 months | 0 | 135850 | 180325 | 27 | 46645 | 27800 | 45025 | 8548.230000 | 8548.23 | 4482.69 | 0.0 | 4065.54 | 37100 | Source Verified |
| 877983 | 0 | 1 | OH | 50000.0 | Individual | 0 | 0.0000 | 0 | N | 1 | 0 | 97851 | Cash | Sep-00 | 684 | 680 | 6050 | 6050.0 | D | N | MORTGAGE | w | 154.46 | 18.25 | Apr-16 | 709 | 705 | 4878.63 | 6050 | Fully Paid | 186 | 8 | 8 | 2 | 0 | 12 | 20 | 20 | 20 | 1 | 20 | 31 | 21 | 21 | 0 | 0 | 1 | 22 | 0.00 | 0.00 | 97.0 | 1 | 0 | 0 | credit_card | n | 0.00 | 34947 | D3 | 0 | 60 months | 0 | 154480 | 171397 | 34 | 37619 | 22250 | 0 | 7646.641827 | 7646.64 | 1596.64 | 0.0 | 6050.00 | 38950 | Source Verified |
| 877984 | 0 | 7 | LA | 591000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97852 | Cash | Sep-95 | 754 | 750 | 30000 | 30000.0 | D | N | MORTGAGE | w | 778.06 | 18.99 | Apr-16 | 539 | 535 | 778.06 | 30000 | Charged Off | 246 | 1 | 1 | 3 | 1 | 1 | 1 | 4 | 6 | 22 | 9 | 15 | 2 | 15 | 0 | 0 | 5 | 15 | 0.00 | 0.00 | 97.3 | 1 | 0 | 0 | debt_consolidation | n | 0.00 | 55154 | D4 | 0 | 60 months | 0 | 109139 | 168698 | 40 | 109139 | 54100 | 61098 | 15650.900000 | 15650.90 | 8580.01 | 0.0 | 7070.89 | 107600 | Not Verified |
| 877985 | 0 | 2 | IN | 52000.0 | Individual | 0 | 0.0000 | 0 | N | 0 | 0 | 97853 | Cash | Aug-02 | 669 | 665 | 5000 | 5000.0 | B | N | MORTGAGE | w | 163.11 | 10.75 | Apr-16 | 764 | 760 | 163.11 | 5000 | Current | 163 | 3 | 3 | 1 | 0 | 3 | 4 | 3 | 4 | 0 | 5 | 7 | 4 | 6 | 0 | 0 | 1 | 6 | 948.38 | 948.38 | 100.0 | 1 | 2 | 1 | credit_card | n | 0.00 | 3979 | B4 | 0 | 36 months | 1445 | 142211 | 161200 | 8 | 3979 | 5200 | 0 | 4890.310000 | 4890.31 | 838.69 | 0.0 | 4051.62 | 6200 | Not Verified |